package boogui.admin;

public class MovieRegistrySQL {
	
	//등록된 전체 지역 조회
	private String allLocationSQL = "select distinct location from cinema";
	//특정 지역의 영화관 조회
	private String cinemaSQL = "select distinct cinename from cinema where location = ?";
	//특정 영화관의 상영관 조회
	private String theaterSQL = "select theater from cinema where cinename = ?";
	
	public String getTheaterSQL() {
		return theaterSQL;
	}

	public void setTheaterSQL(String theaterSQL) {
		this.theaterSQL = theaterSQL;
	}

	public String getCinemaSQL() {
		return cinemaSQL;
	}

	public void setCinemaSQL(String cinemaSQL) {
		this.cinemaSQL = cinemaSQL;
	}

	public String getAllLocationSQL() {
		return allLocationSQL;
	}

	public void setAllLocationSQL(String allLocationSQL) {
		this.allLocationSQL = allLocationSQL;
	}

}
